Here is just to share some of my experience thru an art test back before I started with Cyan with the Firmament project in 2021.

This facade diorama took me about two or three days to complete, a concept was provided for architectural style and scope.
It was really great to work on this individually while maintaining communication with the art director and keeping him updated about progress and art direction. Also, it felt great learning new tricks such as using a MultiUV workflow.

For the completion of the scene, I used:

3Ds Max
ZBrush
Substance Painter
Substance Designer - Wall Bricks 1 & 2
Quixel Mixer - Street Texture, Foundation Bricks, Marble tiles
Photoshop
Megascans - Trash assets, Decals & Textures, Foliage
Unreal Engine 4.26

Workflows:
MultiUV workflow, VertexPainting, Trimsheets, HighPoly/LowPoly